resmgr:pq queued
The session is waiting in the parallel statement queue. Resource Manager is in operation and managing pq operations.
Detailed Description​
Resource Manager is in operation and managing access to parallel query resources. The statement has been placed in the parallel statement queue.
Oracle resource management allows the management of competing workloads within servers and databases. It is used to manage Pluggable Database (PDB) resource consumption within a Container Database (CDB). Control of resources within Maintenance Windows in Oracle is also controlled by the Resource Manager.
How to reduce this wait​
You may see resmgr waits appearing if you have enabled scheduled maintenance window.
Review the resource manager configuration and throttling information to ensure appropriate resources are given to your database.
If server resources are not in short supply, look for throttling within the database for CPU, IO or parallel query resources.
Additional Links​
- Oracle Reference Manual - resmgr:pq queued
- Oracle Administrator's Guide - Managing Resources with Oracle Database Resource Manager
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.